-- Demonstration: Retrieve Data by using the SELECT Statement

-- Example 1: simple query
USE AdventureWorks2008
GO
SELECT *
FROM Sales.SalesOrderHeader


--Example 2: simple query with specific columns
USE AdventureWorks2008
SELECT SalesOrderNumber, OrderDate, SubTotal, TaxAmt, Freight, TotalDue
FROM Sales.SalesOrderHeader